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