UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '64vcaHT+jOB16s3Rpb4CIR5ymocicUZlnRUUb4yJjg8='
WHERE
key_id = '25c0f6887ad5392db2994b9d6b13eb3588c6735430e32661fac7731b4ec51a09'
AND (
token = '64vcaHT+jOB16s3Rpb4CIR5ymocicUZlnRUUb4yJjg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)