UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIwn+XukTl0L4EIKoesMIlrhAq/L+ZF9gtg60tUaPwI='
WHERE
key_id = '7de83dc7fb976dd3b7a33ee01a6ce91294363ef971b749d56747a5dc42149ed6'
AND (
token = 'ZIwn+XukTl0L4EIKoesMIlrhAq/L+ZF9gtg60tUaPwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)