UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MHcBBQGmtm4+sPkkO9kr/DGCrLo/eGHGACHinisgmxk='
WHERE
key_id = 'b29ede1b3e1a6d0183a6818a34550374d168ecdc6a437bdf15d53860de9aff4f'
AND (
token = 'MHcBBQGmtm4+sPkkO9kr/DGCrLo/eGHGACHinisgmxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)