UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3RoF6VSwgD3CMtgTBgftzFH3zTcHq1wEDG58b036VPo='
WHERE
key_id = '138c7535443e84b8a4d873a0fd6bbfaeec88a01b26fe951cae6b101701ee2295'
AND (
token = '3RoF6VSwgD3CMtgTBgftzFH3zTcHq1wEDG58b036VPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)