UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S41lG3lngL5Qn+qlVDxxQ4BokZM+jABr1jtbxl1iDrU='
WHERE
key_id = 'e38d359628fb797b8d9114deaefde78aeea2f6977c3c37e8f597190160f80b96'
AND (
token = 'S41lG3lngL5Qn+qlVDxxQ4BokZM+jABr1jtbxl1iDrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)