UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+pmGljhpC2eI7h/czqoSv49iHxvKmSHaPJA4jEt18+E='
WHERE
key_id = '97af19f043542bbd787e855dc791b2ee9b0edfa93abc98b0dee8fef01a34a1e0'
AND (
token = '+pmGljhpC2eI7h/czqoSv49iHxvKmSHaPJA4jEt18+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)