UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WG6rEauY4IIE8not6KWT7oclQ3CJ8FvNmXalZfI3rJ8='
WHERE
key_id = '1758c733c7aeb6f42f2010b28718e4350f7a1cebb7a4c4e0a060785f40ccee6a'
AND (
token = 'WG6rEauY4IIE8not6KWT7oclQ3CJ8FvNmXalZfI3rJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)