UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '92docE9o0UFd8gjIMF3IorIDfijTFfEt8tN3OLFTyx4='
WHERE
key_id = '8a7020603916cdf1edae661a26f1c14b07eaec73f064f9891242fa5e015811e4'
AND (
token = '92docE9o0UFd8gjIMF3IorIDfijTFfEt8tN3OLFTyx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)