UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROIpjpUoLQ8LOpKZ+onykSGyrbhPf8Q3vlVbQOEiIxw='
WHERE
key_id = '8c6997540fb7fb0bd810ff2a24d29fcd155bb05f12264ffbc9331affaba2086d'
AND (
token = 'ROIpjpUoLQ8LOpKZ+onykSGyrbhPf8Q3vlVbQOEiIxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)