UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'njgZz77rjbcF/HigwYB4AY3RRvVmze4judy1yvOarHs='
WHERE
key_id = '7ea982e404922018bb035e2397e61b8bf1ef7299af20ea93f22ae434a83047fc'
AND (
token = 'njgZz77rjbcF/HigwYB4AY3RRvVmze4judy1yvOarHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)