UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TBN8BOB797TX+mSHIzEYdFHE09KOuLnIjULkmovr2wQ='
WHERE
key_id = '59785d3fe0a95b4cfdc7ed8fb277b5e435ee2f625d9a0dd802a86524dc038533'
AND (
token = 'TBN8BOB797TX+mSHIzEYdFHE09KOuLnIjULkmovr2wQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)