UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JtFcLQ7jbuITbChXFaxlz1R02uk5x7EqsHV+35xJiGY='
WHERE
key_id = 'e2a7ec30d0344f522d14d2c2a32ca4cd6c5bb55d820bd302c4346aa191f63330'
AND (
token = 'JtFcLQ7jbuITbChXFaxlz1R02uk5x7EqsHV+35xJiGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)