UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Fi2YxjAsQCbctLMKdqp1sSy+ZR6SuHn7aBzYEgy3lw='
WHERE
key_id = '329f11bf7f7d397387a565e2b5bfa3303119423868caab4d9d5be20268467787'
AND (
token = '7Fi2YxjAsQCbctLMKdqp1sSy+ZR6SuHn7aBzYEgy3lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)