UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OTNhLCmnXrEWZllYHLP42yQPiSYueTmJonI1Lta7V80='
WHERE
key_id = 'b8c7e9149d9bc11ba1d0fbe029589d0481709f63a5905975e1e465946fcc210b'
AND (
token = 'OTNhLCmnXrEWZllYHLP42yQPiSYueTmJonI1Lta7V80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)