UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l0QwdBU52xfHHNGGovAAoh4QAvisnC4Tnk0p7DP4BUU='
WHERE
key_id = '15f7ba7c4ceb80c74a90f136022a2bee348affe3531ce5f5130dcf78239b87f0'
AND (
token = 'l0QwdBU52xfHHNGGovAAoh4QAvisnC4Tnk0p7DP4BUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)