UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zD+vOO2Xw1fHSfTmCcSKhJ4MFC5lgwJbuHlG+hWMtqo='
WHERE
key_id = 'f77c473a21e3871ae213ffe84c8e6b2d2e289d41863678048076a97d9e90dd60'
AND (
token = 'zD+vOO2Xw1fHSfTmCcSKhJ4MFC5lgwJbuHlG+hWMtqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)