UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBJnThV5ZKb6GjTLiC9Tpt+AwxNEnoDY3xlyxkIy0j8='
WHERE
key_id = '96b7911b80c743c73ed1932691abab1013a007ed6db2362666c40783047aeca1'
AND (
token = 'XBJnThV5ZKb6GjTLiC9Tpt+AwxNEnoDY3xlyxkIy0j8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)