UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UcX7F0LIf0PkdC5nmvyTB4PRDT9PIMAs7nnTdseygBc='
WHERE
key_id = 'bc6ee9dcaa654c07d14f8f84ee3e88f50bf2d7370e8c2063807e572fa0c1b6e6'
AND (
token = 'UcX7F0LIf0PkdC5nmvyTB4PRDT9PIMAs7nnTdseygBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)