UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jolW3LDi0FttTYE2oZ1miJ8PLedD4+NIq13c5ZTyOtI='
WHERE
key_id = '8149a9f67636991bc5d76c3205b40b5cc8f464e416d304a4288a28808422b96d'
AND (
token = 'jolW3LDi0FttTYE2oZ1miJ8PLedD4+NIq13c5ZTyOtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)