UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LoxibgEVwYcMI5hw/nQTv3jeHo36O6atT9U71tv2uwE='
WHERE
key_id = '504cc8dbcadc2b702122237890ba2d8a64b9be8cccdc27e3021ddaa21dedd463'
AND (
token = 'LoxibgEVwYcMI5hw/nQTv3jeHo36O6atT9U71tv2uwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)