UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xls7ajfThxajx7r3zHJMg25Dl8Vb1K+TbnlzNzWjq6w='
WHERE
key_id = '27e63f78e74900e35053fb162f3f63e6b3bca10aab622f1a615c564e139d5afe'
AND (
token = 'Xls7ajfThxajx7r3zHJMg25Dl8Vb1K+TbnlzNzWjq6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)