UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '97WokILNAEuojiisvj1gBSde1FwUszvL426jUFJb9Og='
WHERE
key_id = '8b54a1afd32a6a79829be660291f2500e3eb4080cb3e8ff6d5c62b67bc0a1a0c'
AND (
token = '97WokILNAEuojiisvj1gBSde1FwUszvL426jUFJb9Og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)