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