UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RdcnQubLSPVrlgNAKc59B7bSWzjwKZX88A+dnh2pRfw='
WHERE
key_id = '0c2a7894ffdff751adaed6a880d3b0bebdf662d02a4b123b2fbfcb81b8ce6798'
AND (
token = 'RdcnQubLSPVrlgNAKc59B7bSWzjwKZX88A+dnh2pRfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)