UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zt+ZGg0tdTPKTLuax95AIkRmGZSS3ui+FVVUFbPY4Tw='
WHERE
key_id = '0cd01e7704671cc7a346d16242e9fd5c33aa618340c53c6ae155038c66c9689f'
AND (
token = 'zt+ZGg0tdTPKTLuax95AIkRmGZSS3ui+FVVUFbPY4Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)