UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T4qAfx7865neTci/sa0AR9qK77aK99SEdpCvtX8siJ4='
WHERE
key_id = 'd4b71d2b5bdf937d340712fa495bb483b9d87a25c813f253736b57109cfd990a'
AND (
token = 'T4qAfx7865neTci/sa0AR9qK77aK99SEdpCvtX8siJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)