UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm5NKNVszgol4KYdRxa5tGbSfQQQVKsacVIf1/WISr5o='
WHERE
key_id = 'e7df19fd4e45fb4685e15db5b202d319c5491ed5433e9d4b14d8f017a07fdbe8'
AND (
token = 'm5NKNVszgol4KYdRxa5tGbSfQQQVKsacVIf1/WISr5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)