UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l9z6WWQDwWC3fT5u0h93sSnxP1HydbgZukxMDUlPuDU='
WHERE
key_id = '7278500fb6858a4b4a8404c8219a0e5095ee7e9f1495ab13ca328638ed2ae3a7'
AND (
token = 'l9z6WWQDwWC3fT5u0h93sSnxP1HydbgZukxMDUlPuDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)