UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgjch7EeMyK//A6cyuYMgrKzABRcKV+4uN5/93Xt0q8='
WHERE
key_id = 'd3e9505120cd88ba4635425668a0c45b2daa10ef74e7c416103c37abaa136807'
AND (
token = 'tgjch7EeMyK//A6cyuYMgrKzABRcKV+4uN5/93Xt0q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)