UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUuB8Ac98J1Imqr+7uvK4YToI1pQaWF9G8fi9E85ths='
WHERE
key_id = '05736ff06851aa2bc254459871eacf3e1cc6e1a7a9205c07b9ad670e20ec672b'
AND (
token = 'ZUuB8Ac98J1Imqr+7uvK4YToI1pQaWF9G8fi9E85ths='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)