UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BVqSBBnA2Rn8ykJWpmVun7lH2lpLc4CCTwT0JzbdC8E='
WHERE
key_id = '5c4006b94053eba84185a7cd73c433b9595aaf649746ca9022a1f1e1baf93577'
AND (
token = 'BVqSBBnA2Rn8ykJWpmVun7lH2lpLc4CCTwT0JzbdC8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)